CREATE TABLE [dbo].[Exhb_Booth]
(
[EXHB_ID] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Exhb_Booth_EXHB_ID] DEFAULT (''),
[MEET_ID] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Exhb_Booth_MEET_ID] DEFAULT (''),
[BOOTH_DIM1] [int] NOT NULL CONSTRAINT [DF_Exhb_Booth_BOOTH_DIM1] DEFAULT ((0)),
[BOOTH_DIM2] [int] NOT NULL CONSTRAINT [DF_Exhb_Booth_BOOTH_DIM2] DEFAULT ((0)),
[BOOTH_CORNERS] [tinyint] NOT NULL CONSTRAINT [DF_Exhb_Booth_BOOTH_CORNERS] DEFAULT ((0)),
[MAIN_BOOTH] [bit] NOT NULL CONSTRAINT [DF_Exhb_Booth_MAIN_BOOTH] DEFAULT ((0)),
[BOOTH_NUMBER] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BOOTH_UNITS] [int] NOT NULL CONSTRAINT [DF_Exhb_Booth_BOOTH_UNITS] DEFAULT ((0)),
[PRODUCT_CODE] [varchar] (31) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[EXHB_COMP_ID] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BOOTH_TYPE] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Exhb_Booth_BOOTH_TYPE] DEFAULT (''),
[TIME_STAMP] [timestamp] NULL
) ON [PRIMARY]

GO
CREATE NONCLUSTERED INDEX [iExhb_BoothBOOTH_TYPE] ON [dbo].[Exhb_Booth] ([BOOTH_TYPE]) ON [PRIMARY]
GO
CREATE CLUSTERED INDEX [iExhb_BoothID] ON [dbo].[Exhb_Booth] ([EXHB_ID], [MEET_ID]) ON [PRIMARY]
GO
GRANT REFERENCES ON  [dbo].[Exhb_Booth] TO [IMIS]
GRANT SELECT ON  [dbo].[Exhb_Booth] TO [IMIS]
GRANT INSERT ON  [dbo].[Exhb_Booth] TO [IMIS]
GRANT DELETE ON  [dbo].[Exhb_Booth] TO [IMIS]
GRANT UPDATE ON  [dbo].[Exhb_Booth] TO [IMIS]
GO